﻿-- =============================================
-- Author:		Johan Celis
-- Create date: 30/12/2009
-- Description:	
-- Change: Vertalingen toegevoegd
-- Change: (30/4/2010) analysemethod vanuit andere 'AnalysisMethodGroup' toegevoegd
-- =============================================
ALTER PROCEDURE [dbo].[GetAnalysisMethod] 
	@ID INT
AS
BEGIN
	SELECT
	AnalysisMethodGroup.AnalysisMethodGroupID,
	AnalysisMethod.AnalysisMethodName, 
	AnalysisMethod.AnalysisMethodNameFR,
	AnalysisMethod.AnalysisMethodNameEN,
	AnalysisMethod.AnalysisMethodNameDE,
	AnalysisMethod.AnalysisMethodScientificVersion, AnalysisMethod.Active
	FROM AnalysisMethod
	INNER JOIN AnalysisMethodGroup ON AnalysisMethod.AnalysisMethodGroupID_FK = AnalysisMethodGroup.AnalysisMethodGroupID
	WHERE AnalysisMethod.AnalysisMethodID = @ID
END